{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Лист1","Лист2","Лист3"],"read":"whole","date_system":"1900"}

{"sheet":"Лист1","index":0,"n_rows":257,"n_cols":40,"rows_kept":257,"merged":[[0,0,0,21],[1,0,1,21],[26,0,26,29],[51,0,51,34],[74,0,74,33],[98,0,98,35],[123,0,123,35],[147,0,147,35],[173,0,173,21],[198,0,198,29],[223,0,223,34],[246,0,246,33],[274,0,274,35],[299,0,299,35],[323,0,323,35]]}
["МЕНЮ"]
["1 ДЕНЬ"]
["ЗАВТРАК",10]
["НАИМЕНОВАНИЕ БЛЮДА","выход ","рис","соль","с/м","сахар","молоко","хлеб пшеничный","творог","сметана","сыр","чай","манка","капуста","морковь","лук","п/м","курица","гречка","банан","рыба","сосиска","с/ф","хлеб ржаной","сок","выпечка договор","яблоко","пшено","горох","картофель","макароны","говядина","яйцо","груша","солянка","кр.пшеничная","апельсин","свекла банка","кекс"]
["Каша рисовая молочная с/м",150,0.045,0.005,0.005,0.005,0.1]
["Чай с сахаром",200,{"$nulls":3},0.02,{"$nulls":5},2E-3]
["Хлеб пшеничный с маслом и сыром",165,null,null,0.005,null,null,0.15,null,null,0.01]
["ВЫХОД",{"$f":"SUM(B5:B7)","v":515}]
["ОБЕД"]
["Суп щи с курицей",250,null,2E-3,{"$nulls":9},0.1,0.01,0.01,0.005,0.1,{"$nulls":11},0.07]
["Гречка отварная рассыпчатая",150,null,2E-3,0.01,{"$nulls":13},0.047]
["Сосиска отварная",50,{"$nulls":19},0.05]
["Салат Солянка",60,{"$nulls":32},0.065]
["Компот из сухофруктов",200,{"$nulls":3},0.02,{"$nulls":16},0.02]
["Хлеб ржаной",80,{"$nulls":21},0.08]
["ВЫХОД",{"$f":"SUM(B10:B15)","v":790}]
["ПОЛДНИК"]
["Сок",200,{"$nulls":22},0.2]
["кекс",75,{"$nulls":36},0.075]
["Яблоко",200,{"$nulls":24},0.2]
["ВЫХОД",{"$f":"SUM(B18:B20)","v":475}]
["цена"]
["сумма на одного ученика",null,{"$f":"SUM(C26*C22)","v":0},{"$f":"SUM(D22*D26)","v":0},{"$f":"SUM(E22*E26)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(U22*U26)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AK22*AK26)","v":0},{"$f":"SUM(AL22*AL26)","v":0},0]
["сумма + кол.во детей",null,{"$f":"SUM(C23*65)","v":0},{"$f":"SUM(D23*65)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C24:AM24)","v":0}]
["кол.во продуктов",null,{"$f":"SUM(C26*65)","v":2.925},{"$f":"SUM(D26*65)","v":0.5850000000000001},1.3,2.925,6.5,9.75,0,0,0.65,0.13,0,6.5,0.65,0.65,0.325,6.5,3.055,0,0,3.25,1.3,5.2,13,0,13,0,0,4.550000000000001,0,0,0,0,{"$f":"SUM(AI26*65)","v":4.2250000000000005},0,0,0,4.875]
["ИТОГО ВЫХОД",{"$f":"SUM(B8+B16+B21)","v":1780},{"$f":"SUM(C5:C20)","v":0.045},{"$f":"SUM(D5:D20)","v":0.009000000000000001},0.02,0.045,0.1,0.15,0,0,0.01,2E-3,0,0.1,0.01,0.01,0.005,0.1,0.047,0,0,0.05,0.02,0.08,0.2,0,0.2,0,0,0.07,0,0,0,0,0.065,0,0,0,0.075]
["2 ДЕНЬ"]
["ЗАВТРАК","выход ","рис","соль","с/м","сахар","молоко","хлеб пшеничный","творог","сметана","сыр","чай","манка","капуста","морковь","лук","п/м","курица","гречка","банан","рыба","сосиска","с/ф","хлеб ржаной","сок","выпечка договор","яблоко","пшено","горох","картофель","макароны","говядина","яйцо","груша","солянка","кр.пшеничная","апельсин","свекла банка","кекс"]
["Каша пшенная молочная с/м",150,null,2E-3,0.005,0.005,0.1,{"$nulls":20},0.045]
["Чай с сахаром",200,{"$nulls":3},0.02,{"$nulls":5},2E-3]
["Творог со сметаной",60,{"$nulls":3},0.005,null,null,0.05,0.005]
["Хлеб  пшеничная",150,{"$nulls":5},0.15]
["ВЫХОД",{"$f":"SUM(B29:B32)","v":560}]
["ОБЕД"]
["Суп гороховый с курицей",250,null,2E-3,{"$nulls":10},0.01,0.01,0.005,0.1,{"$nulls":10},0.05,0.07]
["Макароны отварные",150,null,0.005,0.01,{"$nulls":25},0.055]
["Котлеты из говядины",80,null,2E-3,{"$nulls":3},0.01,{"$nulls":7},0.015,0.005,{"$nulls":14},0.123,0.005]
["Салат из капусты",60,null,1E-3,null,0.005,{"$nulls":7},0.094,0.008,null,0.01]
["Компот из сухофруктов",200,{"$nulls":3},0.02,{"$nulls":16},0.02]
["Хлеб ржаной",80,{"$nulls":21},0.08]
["ВЫХОД",{"$f":"SUM(B35:B40)","v":820}]
["ПОЛДНИК"]
["Сок",200,{"$nulls":22},0.2]
["Выпечка договор",75,{"$nulls":23},1]
["Груша",200,{"$nulls":31},0.2]
["ВЫХОД",{"$f":"SUM(B43:B45)","v":475}]
["цена"]
["сумма",null,{"$f":"SUM(C47*C51)","v":0},{"$f":"SUM(D47*D51)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(M47*M51)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(U47*U51)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AK47*AK51)","v":0},0,0]
["сумма + кол.во детей",null,{"$f":"SUM(C48*65)","v":0},{"$f":"SUM(D48*65)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C49:AM49)","v":0}]
["кол.во продуктов",null,{"$f":"SUM(C51*65)","v":0},{"$f":"SUM(D51*65)","v":0.78},0.975,3.5750000000000006,6.5,10.4,3.25,0.325,0,0.13,0,6.11,1.1700000000000002,1.625,1.3,6.5,0,0,0,0,1.3,5.2,13,65,0,2.925,3.25,4.550000000000001,3.575,7.995,0.325,13,0,0,0,0,0]
["ИТОГО ВЫХОД",{"$f":"SUM(B33+B41+B46)","v":1855},{"$f":"SUM(C29:C45)","v":0},0.012,0.015,0.05500000000000001,0.1,0.16,0.05,0.005,0,2E-3,0,0.094,0.018000000000000002,0.025,0.02,0.1,0,0,0,0,0.02,0.08,0.2,1,0,0.045,0.05,0.07,0.055,0.123,0.005,0.2,0,0,0,{"$f":"SUM(AL29:AL45)","v":0},0]
["3 ДЕНЬ"]
["ЗАВТРАК","выход ","рис","соль","с/м","сахар","молоко","хлеб пшеничный","творог","сметана","сыр","чай","манка","капуста","морковь","лук","п/м","курица","гречка","банан","рыба","сосиска","с/ф","хлеб ржаной","сок","выпечка договор","яблоко","пшено","горох","картофель","макароны","говядина","яйцо","груша","солянка","кр.пшеничная","апельсин","свекла банка","кекс"]
["Каша гречневая молочная с/м",150,null,2E-3,0.005,0.005,0.1,{"$nulls":11},0.045]
["Чай с сахаром",200,{"$nulls":3},0.02,{"$nulls":5},2E-3]
["Хлеб с маслом и сыром",165,null,null,0.005,null,null,0.15,null,null,0.01]
["ВЫХОД",{"$f":"SUM(B54:B56)","v":515}]
["ОБЕД"]
["Суп борщ на м/к бульоне с мясом",250,null,2E-3,{"$nulls":9},0.078,0.01,0.01,0.005,{"$nulls":12},0.07,null,0.047,{"$nulls":5},0.035]
["Плов с курицей",200,0.05,0.005,{"$nulls":10},0.02,0.02,0.005,0.087]
["Салат морковный",60,{"$nulls":3},0.005,{"$nulls":8},0.088,null,0.01]
["Компот из сухофруктов",200,{"$nulls":3},0.02,{"$nulls":16},0.02]
["Хлеб ржаной",80,{"$nulls":21},0.08]
["ВЫХОД",{"$f":"SUM(B59:B63)","v":790}]
["ПОЛДНИК"]
["Сок",200,{"$nulls":22},0.2]
["Выпечка договор",75,{"$nulls":23},1]
["Банан",200,{"$nulls":17},0.2]
["ВЫХОД",{"$f":"SUM(B66:B68)","v":475}]
["цена"]
["сумма",null,{"$f":"SUM(C70*C74)","v":0},{"$f":"SUM(D70*D74)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(M70*M74)","v":0},0,0,0,0,0,0,{"$f":"SUM(T70*T74)","v":0},{"$f":"SUM(U70*U74)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AK70*AK74)","v":0},0,0]
["сумма + кол.во детей",null,{"$f":"SUM(C71*65)","v":0},{"$f":"SUM(D71*65)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(M71*65)","v":0},0,0,0,0,0,0,{"$f":"SUM(T71*65)","v":0},{"$f":"SUM(U71*65)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AK71*65)","v":0},0,0,{"$f":"SUM(C72:AM72)","v":0}]
["кол.во продуктов",null,{"$f":"SUM(C74*65)","v":3.25},{"$f":"SUM(D74*65)","v":0.5850000000000001},0.65,3.25,6.5,9.75,0,0,0.65,0.13,0,5.07,7.67,1.95,1.3,5.654999999999999,2.925,13,0,0,1.3,5.2,13,65,0,0,0,4.550000000000001,0,3.055,0,0,0,0,0,2.2750000000000004,0]
["ИТОГО ВЫХОД",{"$f":"SUM(B57+B64+B69)","v":1780},{"$f":"SUM(C54:C68)","v":0.05},0.009000000000000001,0.01,0.05,0.1,0.15,0,0,0.01,2E-3,{"$f":"SUM(M54:M68)","v":0},0.078,0.118,0.03,0.02,0.087,0.045,{"$f":"SUM(T54:T68)","v":0.2},{"$f":"SUM(U54:U68)","v":0},0,0.02,0.08,0.2,1,0,0,0,0.07,0,0.047,0,0,0,0,{"$f":"SUM(AK54:AK68)","v":0},0.035,0]
["4 ДЕНЬ"]
["ЗАВТРАК","выход ","рис","соль","с/м","сахар","молоко","хлеб пшеничный","творог","сметана","сыр","чай","манка","капуста","морковь","лук","п/м","курица","гречка","банан","рыба","сосиска","с/ф","хлеб ржаной","сок","выпечка договор","яблоко","пшено","горох","картофель","макароны","говядина","яйцо","груша","солянка","кр.пшеничная","апельсин","свекла банка","кекс"]
["Каша дружба  с/м (рис+пшено)",150,0.02,0.005,0.005,0.005,0.1,{"$nulls":20},0.025]
["Чай с сахаром",200,{"$nulls":3},0.02,{"$nulls":5},2E-3]
["Хлеб пшеничный с маслом и сыром",165,null,null,0.005,null,null,0.15,null,null,0.01]
["ВЫХОД",{"$f":"SUM(B77:B79)","v":515}]
["ОБЕД"]
["Суп вермешелевый на м/к бульоне с мясом",250,null,2E-3,{"$nulls":10},0.01,0.01,0.005,{"$nulls":12},0.07,0.025,0.047]
["Картофель отварной с/м",150,null,2E-3,0.01,{"$nulls":24},0.189]
["Сосиска отварная",100,{"$nulls":19},0.1]
["капуста тушеная ",60,null,1E-3,{"$nulls":9},0.1433,0.01,0.01,0.005]
["Компот из сухофруктов",200,{"$nulls":3},0.02,{"$nulls":16},0.02]
["Хлеб ржаной",80,{"$nulls":21},0.08]
["ВЫХОД",{"$f":"SUM(B82:B87)","v":840}]
["ПОЛДНИК"]
["сок",200,{"$nulls":22},0.2]
["Яблоко",200,{"$nulls":24},0.2]
["Выпечка договор",75,{"$nulls":23},1]
["ВЫХОД",{"$f":"SUM(B90:B92)","v":475}]
["цена"]
[null,null,{"$f":"SUM(C94*C98)","v":0},{"$f":"SUM(D94*D98)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(M94*M98)","v":0},0,0,0,0,0,0,{"$f":"SUM(T94*T98)","v":0},{"$f":"SUM(U94*U98)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AK94*AK98)","v":0},0,0]
[null,null,{"$f":"SUM(C95*65)","v":0},{"$f":"SUM(D95*65)","v":0},0,0,0,0,{"$f":"SUM(I95*65)","v":0},0,0,0,{"$f":"SUM(M95*65)","v":0},0,0,0,0,0,0,{"$f":"SUM(T95*65)","v":0},{"$f":"SUM(U95*65)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AK95*65)","v":0},0,0,{"$f":"SUM(C96:AM96)","v":0}]
["кол.во продуктов",null,{"$f":"SUM(C98*65)","v":1.3},{"$f":"SUM(D98*65)","v":0.6500000000000001},1.3,2.925,6.5,9.75,0,0,0.65,0.13,0,9.3145,1.3,1.3,0.65,0,0,0,0,6.5,1.3,5.2,13,65,13,1.625,0,16.835,1.625,3.055,0,0,0,0,0,0,0]
["ИТОГО ВЫХОД",{"$f":"SUM(B80+B88+B93)","v":1830},{"$f":"SUM(C77:C92)","v":0.02},0.010000000000000002,0.02,0.045,0.1,0.15,0,0,0.01,2E-3,{"$f":"SUM(M77:M92)","v":0},0.1433,0.02,0.02,0.01,0,0,{"$f":"SUM(T77:T92)","v":0},{"$f":"SUM(U77:U92)","v":0},0.1,0.02,0.08,0.2,1,0.2,0.025,0,0.259,0.025,0.047,0,0,0,0,{"$f":"SUM(AK77:AK92)","v":0},0,0]
["5 ДЕНЬ"]
["ЗАВТРАК","выход ","рис","соль","с/м","сахар","молоко","хлеб пшеничный","творог","сметана","сыр","чай","манка","капуста","морковь","лук","п/м","курица","гречка","банан","рыба","сосиска","с/ф","хлеб ржаной","сок","выпечка договор","яблоко","пшено","горох","картофель","макароны","говядина","яйцо","груша","солянка","кр.пшеничная","апельсин","свекла банка","кекс"]
["Каша пшеничная молочная с/м",150,null,2E-3,0.005,0.005,0.1,{"$nulls":28},0.045]
["Творог со сметаной",60,{"$nulls":3},0.005,null,null,0.05,0.005]
["Чай с сахаром",200,{"$nulls":3},0.02,{"$nulls":5},2E-3]
["Хлеб ",150,{"$nulls":5},0.15]
["ВЫХОД",{"$f":"SUM(B101:B104)","v":560}]
["ОБЕД"]
["Суп рисовый на м/к бульоне с мясом",250,0.025,2E-3,{"$nulls":10},0.01,0.01,0.005,{"$nulls":12},0.07,null,0.047]
["Макароны отварные",150,null,0.005,0.01,{"$nulls":25},0.055]
["Курица отварная",80,null,1E-3,{"$nulls":12},0.005,0.127]
["Салат Солянка",60,{"$nulls":32},0.065]
["Компот из сухофруктов",200,{"$nulls":3},0.02,{"$nulls":16},0.02]
["Хлеб ржаной",80,{"$nulls":21},0.08]
["ВЫХОД",{"$f":"SUM(B107:B112)","v":820}]
["ПОЛДНИК"]
["сок",200,{"$nulls":22},0.2]
["Груша",200,{"$nulls":31},0.2]
["Выпечка договор",75,{"$nulls":23},1]
["ВЫХОД",{"$f":"SUM(B115:B117)","v":475}]
["цена"]
["сумма",null,{"$f":"SUM(C119*C123)","v":0},{"$f":"SUM(D119*D123)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(M119*M123)","v":0},0,0,0,0,0,0,{"$f":"SUM(T119*T123)","v":0},{"$f":"SUM(U119*U123)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AK119*AK123)","v":0},0,0]
["сумма + кол.во детей",null,{"$f":"SUM(C120*65)","v":0},{"$f":"SUM(D120*65)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(M120*65)","v":0},0,0,0,0,0,0,{"$f":"SUM(T120*65)","v":0},{"$f":"SUM(U120*65)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AK120*65)","v":0},0,0,{"$f":"SUM(C121:AM121)","v":0}]
["кол.во продуктов",null,{"$f":"SUM(C123*65)","v":1.625},{"$f":"SUM(D123*65)","v":0.6500000000000001},0.975,3.25,6.5,9.75,3.25,0.325,0,0.13,0,0,0.65,0.65,0.65,8.255,0,0,0,0,1.3,5.2,13,65,0,0,0,4.550000000000001,3.575,3.055,0,13,4.2250000000000005,2.925,0,0,0]
["ИТОГО ВЫХОД",{"$f":"SUM(B105+B113+B118)","v":1855},{"$f":"SUM(C101:C117)","v":0.025},0.010000000000000002,0.015,0.05,0.1,0.15,0.05,0.005,0,2E-3,{"$f":"SUM(M101:M117)","v":0},0,0.01,0.01,0.01,0.127,0,{"$f":"SUM(T101:T117)","v":0},{"$f":"SUM(U101:U117)","v":0},0,0.02,0.08,0.2,1,0,0,0,0.07,0.055,0.047,0,0.2,0.065,0.045,{"$f":"SUM(AK101:AK117)","v":0},0,0]
["6 ДЕНЬ"]
["ЗАВТРАК","выход ","рис","соль","с/м","сахар","молоко","хлеб пшеничный","творог","сметана","сыр","чай","манка","капуста","морковь","лук","п/м","курица","гречка","банан","рыба","сосиска","с/ф","хлеб ржаной","сок","коржик","яблоко","пшено","горох","картофель","макароны","говядина","яйцо","груша","солянка","кр.пшеничная","апельсин","свекла банка","кекс"]
["Каша дружба с/м (рис+гречка)",150,0.02,0.005,0.005,0.005,0.1,{"$nulls":11},0.025]
["Чай с сахаром",200,{"$nulls":3},0.02,{"$nulls":5},2E-3]
["Хлеб пшеничный с маслом и сыром",165,null,null,0.005,null,null,0.15,null,null,0.01]
["ВЫХОД",{"$f":"SUM(B126:B128)","v":515}]
["ОБЕД"]
["Суп борщ на м/к бульоне с мясом",250,null,2E-3,{"$nulls":9},0.078,0.01,0.01,0.005,{"$nulls":12},0.07,null,0.047,{"$nulls":5},0.035]
["Картофель отварной с/м",150,null,2E-3,0.01,{"$nulls":24},0.189]
["Котлеты из говядины",80,null,2E-3,{"$nulls":3},0.01,{"$nulls":7},0.015,0.005,{"$nulls":14},0.123,0.005]
["Салат морковный",60,{"$nulls":3},2E-3,{"$nulls":8},0.088,null,0.01]
["Компот из сухофруктов",200,{"$nulls":3},0.02,{"$nulls":16},0.02]
["Хлеб ржаной",80,{"$nulls":21},0.08]
["ВЫХОД",{"$f":"SUM(B131:B136)","v":820}]
["ПОЛДНИК"]
["сок",200,{"$nulls":22},0.2]
["Яблоко",200,{"$nulls":24},0.2]
["Выпечка договор",75,{"$nulls":23},1]
["ВЫХОД",{"$f":"SUM(B139:B141)","v":475}]
["цена"]
["сумма",null,{"$f":"SUM(C143*C147)","v":0},{"$f":"SUM(D143*D147)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(T143*T147)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AK143*AK147)","v":0},0,0]
["сумма + кол.во детей",null,{"$f":"SUM(C144*65)","v":0},{"$f":"SUM(D144*65)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(T144*65)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AG144*65)","v":0},0,0,0,{"$f":"SUM(AK144*65)","v":0},0,0,{"$f":"SUM(C145:AM145)","v":0}]
["кол.во продуктов",null,{"$f":"SUM(C147*65)","v":1.3},{"$f":"SUM(D147*65)","v":0.7150000000000001},1.3,3.055,6.5,10.4,0,0,0.65,0.13,0,5.07,6.369999999999999,1.625,1.3,0,1.625,0,0,0,1.3,5.2,13,65,13,0,0,16.835,0,11.049999999999999,0.325,0,0,0,0,2.2750000000000004,0]
["ИТОГО ВЫХОД",{"$f":"SUM(B129+B137+B142)","v":1810},{"$f":"SUM(C126:C141)","v":0.02},0.011000000000000001,0.02,0.047,0.1,0.16,0,0,0.01,2E-3,0,0.078,0.09799999999999999,0.025,0.02,0,0.025,{"$f":"SUM(T126:T141)","v":0},0,0,0.02,0.08,0.2,1,0.2,0,0,0.259,0,0.16999999999999998,0.005,0,0,0,{"$f":"SUM(AK126:AK141)","v":0},0.035,0]
["7 ДЕНЬ"]
["ЗАВТРАК","выход ","рис","соль","с/м","сахар","молоко","хлеб пшеничный","творог","сметана","сыр","чай","манка","капуста","морковь","лук","п/м","курица","гречка","банан","рыба","сосиска","с/ф","хлеб ржаной","сок","выпечка договор","яблоко","пшено","горох","картофель","макароны","говядина","яйцо","груша","солянка","кр.пшеничная","апельсин","свекла банка","кекс"]
["Каша пшенная молочная с/м",150,null,2E-3,0.005,0.005,0.1,{"$nulls":20},0.045]
["Чай с сахаром",200,{"$nulls":3},0.02,{"$nulls":5},2E-3]
["Хлеб пшеничный с маслом и сыром",165,null,null,0.005,null,null,0.15,null,null,0.01]
["ВЫХОД",{"$f":"SUM(B150:B152)","v":515}]
["ОБЕД"]
["Суп гороховый с курицей",250,null,2E-3,{"$nulls":10},0.01,0.01,0.005,0.1,{"$nulls":9},",",0.05,0.07]
["Каша гречневая молочная с/м",150,null,2E-3,0.01,{"$nulls":13},0.047]
["рыба тушеная с овощами",100,null,2E-3,{"$nulls":10},0.02,0.02,0.005,{"$nulls":3},0.127]
["салат из св.капусты",60,null,1E-3,null,2E-3,{"$nulls":7},0.094,0.008,null,0.01]
["Компот из сухофруктов",200,{"$nulls":3},0.02,{"$nulls":16},0.02]
["Хлеб ржаной",80,{"$nulls":21},0.08]
["ВЫХОД",{"$f":"SUM(B155:B160)","v":840}]
["ПОЛДНИК"]
["сок",200,{"$nulls":22},0.2]
["Банан",200,{"$nulls":17},0.2]
["Кекс",75,{"$nulls":36},0.075]
["ВЫХОД",{"$f":"SUM(B163:B165)","v":475}]
["цена"]
["сумма",null,{"$f":"SUM(C167*C171)","v":0},{"$f":"SUM(D167*D171)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(T167*T171)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AK167*AK171)","v":0},0,0]
["сумма + кол.во детей",null,{"$f":"SUM(C168*65)","v":0},{"$f":"SUM(D168*65)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(T168*65)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AK168*65)","v":0},0,0,{"$f":"SUM(C169:AM169)","v":0}]
["кол.во продуктов",null,{"$f":"SUM(C171*65)","v":0},{"$f":"SUM(D171*65)","v":0.5850000000000001},1.3,3.055,6.5,9.75,0,0,0.65,0.13,0,6.11,2.4699999999999998,1.95,1.3,6.5,3.055,13,8.255,0,1.3,5.2,13,0,0,2.925,3.25,4.550000000000001,0,0,0,0,0,0,0,0,4.875]
["ИТОГО ВЫХОД",{"$f":"SUM(B153+B161+B166)","v":1830},{"$f":"SUM(C150:C165)","v":0},0.009000000000000001,0.02,0.047,0.1,0.15,0,0,0.01,2E-3,0,0.094,0.038,0.03,0.02,0.1,0.047,{"$f":"SUM(T150:T165)","v":0.2},0.127,0,0.02,0.08,0.2,0,0,0.045,0.05,0.07,0,0,0,0,0,0,{"$f":"SUM(AK150:AK165)","v":0},0,0.075]
[]
[]
["8 ДЕНЬ"]
["ЗАВТРАК"]
["НАИМЕНОВАНИЕ БЛЮДА","выход ","рис","соль","с/м","сахар","молоко","хлеб пшеничный","творог","сметана","сыр","чай","манка","капуста","морковь","лук","п/м","курица","гречка","банан","рыба","сосиска","с/ф","хлеб ржаной","сок","выпечка договор","яблоко","пшено","горох","картофель","макароны","говядина","яйцо","груша","солянка","кр.пшеничная","апельсин","свекла банка","кекс"]
["Каша манная молочная с/м",150,0.045,0.005,0.005,0.005,0.1,{"$nulls":5},0.045]
["Чай с сахаром",200,{"$nulls":3},0.02,{"$nulls":5},2E-3]
["Хлеб пшеничный с маслом и сыром",165,null,null,0.005,null,null,0.15,null,null,0.01]
["ВЫХОД",{"$f":"SUM(B177:B179)","v":515}]
["ОБЕД"]
["Суп щи с мясом на м/к бульоне",250,2E-3,{"$nulls":10},0.1,0.01,0.01,0.005,{"$nulls":12},0.07,null,0.055]
["Рис отварной",150,0.05,0.005,0.01]
["курица отварная",80,null,2E-3,{"$nulls":12},0.005,0.102]
["Салат солянка",60,{"$nulls":32},0.065]
["Компот из сухофруктов",200,{"$nulls":3},0.02,{"$nulls":16},0.02]
["Хлеб ржаной",80,{"$nulls":21},0.08]
["ВЫХОД",{"$f":"SUM(B182:B187)","v":820}]
["ПОЛДНИК"]
["Сок",200,{"$nulls":22},0.2]
["Выпечка договор",75,{"$nulls":23},1]
["апельсин",200,{"$nulls":34},0.2]
["ВЫХОД",{"$f":"SUM(B190:B192)","v":475}]
["цена"]
["сумма на одного ученика",null,{"$f":"SUM(C198*C194)","v":0},{"$f":"SUM(D194*D198)","v":0},{"$f":"SUM(E194*E198)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(T194*T198)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AK194*AK198)","v":0},0,0]
["сумма + кол.во детей",null,{"$f":"SUM(C195*65)","v":0},{"$f":"SUM(D195*65)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(T195*65)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AK195*65)","v":0},0,0]
["кол.во продуктов",null,{"$f":"SUM(C198*65)","v":6.305000000000001},{"$f":"SUM(D198*65)","v":0.78},1.3,2.925,6.5,{"$f":"SUM(H198*65)","v":9.75},0,0,0.65,0.13,2.925,6.5,0.65,0.65,0.65,6.63,0,0,0,0,1.3,5.2,13,65,0,0,0,4.550000000000001,0,3.575,0,0,4.2250000000000005,0,13,0,0]
["ИТОГО ВЫХОД",{"$f":"SUM(B180+B188+B193)","v":1810},{"$f":"SUM(C177:C192)","v":0.097},{"$f":"SUM(D177:D192)","v":0.012},0.02,0.045,0.1,{"$f":"SUM(H177:H192)","v":0.15},{"$f":"SUM(I177:I192)","v":0},0,0.01,2E-3,0.045,0.1,0.01,0.01,0.01,0.102,0,{"$f":"SUM(T177:T192)","v":0},0,0,0.02,0.08,0.2,1,0,0,0,0.07,0,0.055,0,0,0.065,0,{"$f":"SUM(AK177:AK192)","v":0.2},0,0]
["9 ДЕНЬ"]
["ЗАВТРАК","выход ","рис","соль","с/м","сахар","молоко","хлеб пшеничный","творог","сметана","сыр","чай","манка","капуста","морковь","лук","п/м","курица","гречка","банан","рыба","сосиска","с/ф","хлеб ржаной","сок","выпечка договор","яблоко","пшено","горох","картофель","макароны","говядина","яйцо","груша","солянка","кр.пшеничная","апельсин","свекла банка","кекс"]
["Каша пшеничная молочная с/м",150,null,2E-3,0.005,0.005,0.1,{"$nulls":28},0.045]
["Чай с сахаром",200,{"$nulls":3},0.02,{"$nulls":5},2E-3]
["Творог со сметаной",60,{"$nulls":3},0.005,null,null,0.05,0.005]
["Хлеб  пшеничная",150,{"$nulls":5},0.15]
["ВЫХОД",{"$f":"SUM(B201:B204)","v":560}]
["ОБЕД"]
["Суп гороховый с курицей",250,null,2E-3,{"$nulls":10},0.01,0.01,0.005,0.1,{"$nulls":10},0.05,0.07]
["Макароны отварные",150,null,0.005,0.01,{"$nulls":25},0.055]
["тефтели из говядины",80,0.01,2E-3,{"$nulls":3},0.01,{"$nulls":7},0.015,0.005,{"$nulls":14},0.123,0.005]
["Салат из капусты",60,null,1E-3,null,0.005,{"$nulls":7},0.094,0.008,null,0.01]
["Компот из сухофруктов",200,{"$nulls":3},0.02,{"$nulls":16},0.02]
["Хлеб ржаной",80,{"$nulls":21},0.08]
["ВЫХОД",{"$f":"SUM(B207:B212)","v":820}]
["ПОЛДНИК"]
["Сок",200,{"$nulls":22},0.2]
["Выпечка договор",75,{"$nulls":23},1]
["Груша",200,{"$nulls":31},0.2]
["ВЫХОД",{"$f":"SUM(B215:B217)","v":475}]
["цена"]
["сумма",null,{"$f":"SUM(C219*C223)","v":0},{"$f":"SUM(D219*D223)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(T219*T223)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AK219*AK223)","v":0},0,0]
["сумма + кол.во детей",null,{"$f":"SUM(C220*65)","v":0},{"$f":"SUM(D220*65)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(T220*65)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,79.68,{"$f":"SUM(AH220*65)","v":0},0,0,{"$f":"SUM(AK220*65)","v":0},0,0]
["кол.во продуктов",null,{"$f":"SUM(C223*65)","v":0.65},{"$f":"SUM(D223*65)","v":0.78},0.975,3.5750000000000006,6.5,10.4,{"$f":"SUM(I223*65)","v":3.25},0.325,0,0.13,0,6.11,1.1700000000000002,1.625,1.3,6.5,0,0,0,0,1.3,5.2,13,65,0,0,3.25,4.550000000000001,3.575,7.995,8,13,0,2.925,0,0,0]
["ИТОГО ВЫХОД",{"$f":"SUM(B205+B213+B218)","v":1855},{"$f":"SUM(C201:C217)","v":0.01},0.012,0.015,0.05500000000000001,0.1,0.16,0.05,0.005,0,2E-3,0,0.094,0.018000000000000002,0.025,0.02,0.1,0,{"$f":"SUM(T201:T217)","v":0},0,0,0.02,0.08,0.2,1,0,0,0.05,0.07,0.055,0.123,0.005,0.2,0,0.045,0,{"$f":"SUM(AL201:AL217)","v":0},0]
["10 ДЕНЬ"]
["ЗАВТРАК","выход ","рис","соль","с/м","сахар","молоко","хлеб пшеничный","творог","сметана","сыр","чай","манка","капуста","морковь","лук","п/м","курица","гречка","банан","рыба","сосиска","с/ф","хлеб ржаной","сок","выпечка договор","яблоко","пшено","горох","картофель","макароны","говядина","яйцо","груша","солянка","кр.пшеничная","апельсин","свекла банка","кекс"]
["Каша гречневая молочная с/м",150,null,2E-3,0.005,0.005,0.1,{"$nulls":11},0.045]
["Чай с сахаром",200,{"$nulls":3},0.02,{"$nulls":5},2E-3]
["Хлеб с маслом и сыром",165,null,null,0.005,null,null,0.15,null,null,0.01]
["ВЫХОД",{"$f":"SUM(B226:B228)","v":515}]
["ОБЕД"]
["Суп борщ  с курицей",250,null,2E-3,{"$nulls":9},0.078,0.01,0.01,0.005,0.1,{"$nulls":11},0.07,null,0.047,{"$nulls":5},0.035]
["овощное рагу с мясом",200,null,0.005,0.005,{"$nulls":9},0.02,0.02,0.005,{"$nulls":12},0.187,null,0.058]
["Салат морковный",60,{"$nulls":3},0.005,{"$nulls":8},0.088,null,0.01]
["Компот из сухофруктов",200,{"$nulls":3},0.02,{"$nulls":16},0.02]
["Хлеб ржаной",80,{"$nulls":21},0.08]
["ВЫХОД",{"$f":"SUM(B231:B235)","v":790}]
["ПОЛДНИК"]
["Сок",200,{"$nulls":22},0.2]
["Выпечка договор",75,{"$nulls":23},1]
["Яблоко",200,{"$nulls":24},0.2]
["ВЫХОД",{"$f":"SUM(B238:B240)","v":475}]
["цена"]
["сумма",null,{"$f":"SUM(C242*C246)","v":0},{"$f":"SUM(D242*D246)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(T242*T246)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AL242*AL246)","v":0},0]
["сумма + кол.во детей",null,{"$f":"SUM(C243*65)","v":0},{"$f":"SUM(D243*65)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(T243*65)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AL243*65)","v":0},0]
["кол.во продуктов",null,{"$f":"SUM(C246*65)","v":0},{"$f":"SUM(D246*65)","v":0.5850000000000001},0.975,3.25,6.5,9.75,0,0,0.65,0.13,0,5.07,7.67,1.95,1.3,6.5,2.925,0,0,0,1.3,5.2,13,65,13,0,0,16.705000000000002,0,6.825000000000001,0,0,0,0,0,2.2750000000000004,0]
["ИТОГО ВЫХОД",{"$f":"SUM(B229+B236+B241)","v":1780},{"$f":"SUM(C226:C240)","v":0},0.009000000000000001,0.015,0.05,0.1,0.15,0,0,0.01,2E-3,0,0.078,0.118,0.03,0.02,0.1,0.045,{"$f":"SUM(T226:T240)","v":0},0,0,0.02,0.08,0.2,1,0.2,0,0,0.257,0,0.10500000000000001,0,0,0,0,0,{"$f":"SUM(AL226:AL240)","v":0.035},0]
[]
["итого на одного ученика на 10 дн",null,{"$f":"SUM(C26+C51+C74+C98+C123+C147+C171+C198+C223+C246)","v":0.267},{"$f":"SUM(D26+D51+D74+D98+D123+D147+D171+D198+D223+D246)","v":0.10300000000000001},0.17000000000000004,0.48899999999999993,0.9999999999999999,1.5299999999999998,0.15000000000000002,0.015,0.07,0.020000000000000004,0.045,0.8593,0.45799999999999996,0.215,0.155,0.816,0.20899999999999996,0.4,0.127,0.15000000000000002,0.19999999999999998,0.7999999999999999,1.9999999999999998,8,0.8,0.115,0.15000000000000002,1.2650000000000001,0.19,0.7169999999999999,0.015,0.6000000000000001,0.195,0.09,0.2,0.10500000000000001,0.15]
["ЗАВТРАК","выход ","рис","соль","с/м","сахар","молоко","хлеб пшеничный","творог","сметана","сыр","чай","манка","капуста","морковь","лук","п/м","курица","гречка","банан","рыба","сосиска","с/ф","хлеб ржаной","сок","выпечка договор","яблоко","пшено","горох","картофель","макароны","говядина","яйцо","груша","солянка","кр.пшеничная","апельсин","свекла банка","кекс"]
[]
[]
[]
["итого на 21 дн на одного ученика",25,{"$f":"SUM(C248*2)+C26","v":0.5790000000000001},0.21500000000000002,0.3600000000000001,1.023,2.0999999999999996,3.2099999999999995,0.30000000000000004,0.03,0.15000000000000002,0.04200000000000001,0.09,1.8186,0.9259999999999999,0.44,0.315,1.732,0.4649999999999999,0.8,0.254,0.35000000000000003,0.42,1.68,4.199999999999999,16,1.8,0.23,{"$f":"SUM(AC248*2)+AC26","v":0.30000000000000004},2.6,0.38,1.4339999999999997,0.03,1.2000000000000002,0.455,0.18,{"$f":"SUM(AK248*2)+AK26","v":0.4},{"$f":"SUM(AL248*2)+AL26","v":0.21000000000000002},0.375]
[null,null,{"$f":"C253*$B253","v":14.475000000000001},{"$f":"D253*$B253","v":5.375000000000001},9.000000000000002,25.575,52.49999999999999,80.24999999999999,7.500000000000001,0.75,3.7500000000000004,1.0500000000000003,2.25,45.465,23.15,11,7.875,43.3,11.624999999999998,{"$f":"T253*$B253","v":20},6.35,8.75,10.5,42,104.99999999999999,400,45,5.75,7.500000000000001,65,9.5,35.849999999999994,0.75,30.000000000000004,11.375,4.5,{"$f":"AK253*$B253","v":10},{"$f":"AL253*$B253","v":5.250000000000001},9.375]
[]
["итого на одного ученика на 18 дн",30,{"$f":"SUM(C248+C26+C51+C74+C98+C123+C147+C171)","v":0.42700000000000005},{"$f":"SUM(D248+D26+D51+D74+D98+D123+D147+D171)","v":0.17300000000000004},0.29000000000000004,0.8280000000000002,1.7000000000000004,2.5999999999999996,0.25,0.025,0.11999999999999998,0.034000000000000016,0.045,1.4466,0.77,0.3650000000000001,0.26,1.33,0.37299999999999994,0.8,0.254,0.30000000000000004,0.34,1.36,3.400000000000001,13,1.4,0.22999999999999998,0.25,2.1330000000000005,0.325,1.151,0.025,1,0.325,0.135,0.2,{"$f":"SUM(AL248+AL26+AL51+AL74+AL98+AL123+AL147+AL171)","v":0.17500000000000002},0.3]
[null,null,{"$f":"C256*$B256","v":12.810000000000002},{"$f":"D256*$B256","v":5.190000000000001},8.700000000000001,24.840000000000007,51.000000000000014,77.99999999999999,7.5,0.75,3.5999999999999996,1.0200000000000005,1.3499999999999999,43.398,23.1,10.950000000000003,7.800000000000001,39.900000000000006,11.189999999999998,{"$f":"T256*$B256","v":24},7.62,9.000000000000002,10.200000000000001,40.800000000000004,102.00000000000003,390,42,6.8999999999999995,7.5,63.990000000000016,9.75,34.53,0.75,30,9.75,4.050000000000001,6,{"$f":"AL256*$B256","v":5.250000000000001},9]

{"sheet":"Лист2","index":1,"n_rows":8,"n_cols":36,"rows_kept":8}
[]
[null,"рис","соль","с/м","сахар","молоко","хлеб пшеничный","творог","сметана","сыр","чай","манка","капуста","морковь","лук","п/м","курица","гречка","рыба","сосиска","с/ф","хлеб ржаной","сок","выпечка договор","яблоко","пшено","горох","картофель","макароны","говядина","яйцо","груша","свекла","кр.пшеничная","апельсин","кекс"]
[]
[21,0.525,0.21200000000000002,0.37,0.983,2.0999999999999996,3.2099999999999995,0.30000000000000004,0.03,0.17,0.04200000000000001,0.09,2.0906,1.088,0.44,0.38499999999999995,1.732,0.4649999999999999,0.254,0.45,0.38,1.68,4.199999999999999,16,2.6,0.23,0.30000000000000004,2.6,0.38,1.4339999999999997,0.03,1.2000000000000002,1.1139999999999999,0.18,0.4,0.375]
[]
[18,0.37500000000000006,0.17000000000000004,0.3,0.7880000000000003,1.7000000000000004,2.5999999999999996,0.25,0.025,0.13999999999999999,0.034000000000000016,0.045,1.7066000000000003,0.9050000000000001,0.3650000000000001,0.31,1.33,0.37299999999999994,0.254,0.35,0.3,1.36,3.400000000000001,13,2.1999999999999997,0.22999999999999998,0.25,2.1330000000000005,0.325,1.151,0.025,1,0.83,0.135,0.2,0.3]
[]
[100]

{"sheet":"Лист3","index":2,"n_rows":15,"n_cols":5,"rows_kept":15}
[]
[{"$nulls":4},10]
[null,null,"рис",0.525,{"$f":"SUM(D3*E2)","v":5.25}]
[null,null,"соль",0.212]
[null,null,"с/м",0.37]
[null,null,"сахар",0.983]
[null,null,"молоко",2.1]
[null,null,"хлеб пшенич",3.21]
[null,null,"творог",0.3]
[null,null,"сметана",0.03]
[null,null,"сыр",0.17]
[null,null,"чай",0.042]
[null,null,"манка",0.09]
[null,null,"капуста",2.09]
[null,null,"морковь",1.088]